2015-11-02 - 22823 - Enhancement - Exclude Retail Customers #BExQueriesforCrystalReportsAnalysisTool

SPECIFICATIONS

22823 - Exlude Retail Customers

Purpose

Need to exclude/include the following Retail and Intercompany customers from all BEx Queries:
1017049
1017054
1017055
1017056
1018680
1018681
1018682
1018689

Admin Info


Purpose
 Need to exclude the Retail & Intercompany customers from all BEx Queries.
Requested By
 Takehiko Kurata
Spec Created By
 Uday Kumar P
Spec Created Date
 11/02/2015
Spec QA by
 Uday Kumar P
Objects
 BEx Queries & Intercompany Customers attached.
Document Status
 Complete

Estimates


SNo
 Activity
 Estimation in Hours
1
 Research
 00
2
 Documentation
 08
3
 Development/ Config
 32
4
 Unit test in DEV
 05
5
 Unit test in QUA
 05

TOTAL
 50

References

Prior Tickets

None

Documents

None

Spec Changes


SNo
 Change Details
 Requested By
 Requested On
 Notes if any

























Functional Requirement

Purpose/WHY:

Need to exclude/include the following Retail and Intercompany customers from all BEx Queries:
1017049
1017054
1017055
1017056
1018680
1018681
1018682
1018689

In Scope:

Need to exclude new Japan Retail and Intercompany Customers 1017049, 1017054, 1017055, 1017056, 1018680,1018681, 1018682 & 1018689 from all the BEx queries in BPD(BW 7.3 Development) and transport the requests to BPQ & BPP.

Out of Scope:

None

Solution Summary

1. Create an open BEx transport request in BPD.
2. Exclude new Retail & Intercompany Customers for 0CUSTOMER (or) 0SOLD_TO info objects in the BEx filter section.
3. Collect all the queries for an infoprovider into one open transport request.
4. Transport it to BPQ for testing and move it to BPP after successful testing.
5. Need to exclude the above customers manually in OSA100 and OSA180 Global and regional reports.

Test Plan

SNo
 Test Scenario
 Expected Results
1
 Check whether the changes are collected into the transport request.
 All the changes should be collected into the transport request.
2
 Check if all the Retail & Intercompany Customers(60) are excluded in BEx queries.
 All Retail & Intercompany customers(60) should be excluded in BEx queries.
3
 Check if all the changes meet the BEx QA Standards as per checklist.
 BEx Query should pass all the QA test cases as in checklist.

Solution Details
1. Create an Open transport request in BPD(BW 7.3 Development).
2. Exclude new Retail & Intercompany Customers 1017049, 1017054, 1017055, 1017056, 1018680,1018681, 1018682 & 1018689 for 0CUSTOMER (or) 0SOLD_TO info objects in the BEx filter section.
3. Collect all the queries for an infoprovider into the open transport request.
4. Transport it to BPQ(BW 7.3 Quality) for testing and move it to BPP(BW 7.3 Production) after successful testing.
5. The list of all BEx Queries in which Japan Retail and Intercompany customers are excluded or included are attached here for reference:


Global BEx Queries for exclusion 10-30-2015.xls
Regional BEx Queries for Exclusion 10-30-2015.xlsx

6.The list of all updated Retail and Intercompany Customers(60) is attached here for reference:
InterCompany Customers 10-30-2015.txt

7. Need to exclude the above customers manually in OSA100 and OSA180 Global and regional reports.

Issues

1. Some of the BEx queries need the intercompany customers to be included as specified in the attached spreadsheet.
2. All Exclusions/Inclusions need to be manually updated to each BEx query and cannot be updated globally.
3. OSA100 and OSA180 reports need to be updated manually for customer exclusion.